If you want to do it this way then this is the syntax you're after; IF EXISTS (SELECT * FROM tblGLUserAccess WHERE GLUserName ='xxxxxxxx') ... ... <看更多>

If EXISTS ( SELECT databasename FROM somedb.dbo.bigtable l LEFT JOIN ... When using EXISTS or NOT EXISTS the SQL Server generated query plan with NESTED LOOP ... ... <看更多>